﻿IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[ContarLogServicio]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[ContarLogServicio]
GO

CREATE PROCEDURE [dbo].[ContarLogServicio]
(
	@IdEstado int
)
AS
BEGIN

	SELECT COUNT(*)
	FROM [LogServicio]
	where IdEstado = @IdEstado

END

GO
